ER Model

An ER diagram for the COMPANY database

Summary of ER diagram notation

Relational Database Model

The COMPANY relational database schema (where primary keys are underlined)

A relational database example of the COMPANY schema

Referential integrity constraints (with foreign keys linking to primary keys) displayed on the COMPANY schema

The figures are adopted from --- Fundamentals of Database System, R. Elmasri and S. B. Navathe, Benjamin/Cummings Inc., 2^nd Edition, 1994

If these figures are too big for your computer screen, it is suggested that you download them and view them with any imaging tool.